Pandas Profiling Report

Dataset info

Number of variables	31
Number of observations	821723
Missing cells	2296145 (9.0%)
Duplicate rows	0 (0.0%)
Total size in memory	188.9 MiB
Average record size in memory	241.0 B

Variables types

Numeric	3
Categorical	24
Boolean	1
Date	0
URL	0
Text (Unique)	0
Rejected	3
Unsupported	0

Warnings

`age_at_incident` has 13351 (1.6%) missing values	Missing
`arraignment_date` has a high cardinality: 3206 distinct values	Warning
`arraignment_date` has 141443 (17.2%) missing values	Missing
`arrest_date` has a high cardinality: 258283 distinct values	Warning
`arrest_date` has 17929 (2.2%) missing values	Missing
`case_participant_id` is highly correlated with `case_id` (ρ = 0.9862112296)	Rejected
`charge_disposition_reason` has 602411 (73.3%) missing values	Missing
`charge_id` is highly correlated with `case_participant_id` (ρ = 0.9583841653)	Rejected
`charge_version_id` is highly correlated with `charge_id` (ρ = 0.9683668011)	Rejected
`court_facility` has 8469 (1.0%) missing values	Missing
`disposition_charged_act` has a high cardinality: 52 distinct values	Warning
`disposition_charged_act` has 23341 (2.8%) missing values	Missing
`disposition_charged_aoic` has a high cardinality: 3298 distinct values	Warning
`disposition_charged_chapter` has a high cardinality: 858 distinct values	Warning
`disposition_charged_offense_title` has a high cardinality: 2302 distinct values	Warning
`disposition_charged_section` has a high cardinality: 1635 distinct values	Warning
`disposition_charged_section` has 23341 (2.8%) missing values	Missing
`disposition_date` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`disposition_date` has a high cardinality: 2802 distinct values	Warning
`incident_begin_date` has a high cardinality: 6465 distinct values	Warning
`incident_city` has a high cardinality: 268 distinct values	Warning
`incident_city` has 73668 (9.0%) missing values	Missing
`incident_end_date` has a high cardinality: 4287 distinct values	Warning
`incident_end_date` has 729228 (88.7%) missing values	Missing
`judge` has a high cardinality: 403 distinct values	Warning
`judge` has 69566 (8.5%) missing values	Missing
`law_enforcement_agency` has a high cardinality: 525 distinct values	Warning
`offense_category` has a high cardinality: 88 distinct values	Warning
`received_date` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`received_date` has a high cardinality: 6033 distinct values	Warning
`unit` has a high cardinality: 101 distinct values	Warning
`unit` has 571681 (69.6%) missing values	Missing
`updated_offense_category` has a high cardinality: 81 distinct values	Warning

age_at_incident
Numeric

Distinct count	88
Unique (%)	< 0.1%
Missing (%)	1.6%
Missing (n)	13351
Infinite (%)	0.0%
Infinite (n)	0

Mean	31.91356826
Minimum	17
Maximum	156
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	17
5-th percentile	18
Q1	22
Median	29
Q3	39
95-th percentile	55
Maximum	156
Range	139
Interquartile range	17

Descriptive statistics

Standard deviation	11.72520023
Coef of variation	0.3674048647
Kurtosis	0.1671993046
Mean	31.91356826
MAD	9.628208641
Skewness	0.8955357052
Sum	25798035
Variance	137.4803204
Memory size	6.3 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19	44294	5.4%
20	43202	5.3%
21	39147	4.8%
22	36973	4.5%
23	36110	4.4%
24	33820	4.1%
18	32061	3.9%
25	31087	3.8%
26	30363	3.7%
27	28925	3.5%
Other values (77)	452390	55.1%

Minimum 5 values

Value	Count	Frequency (%)
17	12943	1.6%
18	32061	3.9%
19	44294	5.4%
20	43202	5.3%
21	39147	4.8%

Maximum 5 values

Value	Count	Frequency (%)
156	1	< 0.1%
130	1	< 0.1%
127	2	< 0.1%
125	1	< 0.1%
124	1	< 0.1%

arraignment_date
Categorical

Distinct count	3206
Unique (%)	0.4%
Missing (%)	17.2%
Missing (n)	141443

2/14/2012 12:00:00 AM	944
12/6/2011 12:00:00 AM	935
3/20/2014 12:00:00 AM	896
Other values (3202)	677505
(Missing)	141443

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2/14/2012 12:00:00 AM	944	0.1%
12/6/2011 12:00:00 AM	935	0.1%
3/20/2014 12:00:00 AM	896	0.1%
9/3/2013 12:00:00 AM	872	0.1%
12/13/2011 12:00:00 AM	760	0.1%
9/8/2011 12:00:00 AM	759	0.1%
11/17/2011 12:00:00 AM	752	0.1%
2/19/2013 12:00:00 AM	725	0.1%
2/21/2012 12:00:00 AM	722	0.1%
4/18/2013 12:00:00 AM	721	0.1%
Other values (3195)	672194	81.8%
(Missing)	141443	17.2%

Max length	22
Mean length	17.85882469
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

arrest_date
Categorical

Distinct count	258283
Unique (%)	31.4%
Missing (%)	2.2%
Missing (n)	17929

3/10/2012 1:49:00 AM	326
4/14/2010 5:51:00 AM	301
3/1/2013 11:55:00 AM	294
Other values (258279)	802873
(Missing)	17929

Toggle details

Common values
Composition

Value	Count	Frequency (%)
3/10/2012 1:49:00 AM	326	< 0.1%
4/14/2010 5:51:00 AM	301	< 0.1%
3/1/2013 11:55:00 AM	294	< 0.1%
1/25/2012 10:40:00 AM	287	< 0.1%
8/1/2013 8:15:00 PM	262	< 0.1%
10/18/2011 9:06:00 AM	244	< 0.1%
12/28/2011 3:30:00 PM	218	< 0.1%
1/2/2011 1:42:00 AM	216	< 0.1%
11/2/2008 4:40:00 AM	198	< 0.1%
3/30/2017 10:58:00 AM	195	< 0.1%
Other values (258272)	801253	97.5%
(Missing)	17929	2.2%

Max length	22
Mean length	19.8829058
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

case_id
Numeric

Distinct count	291211
Unique (%)	35.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.182481192e+11
Minimum	4.467030971e+10
Maximum	1.312048319e+11
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4.467030971e+10
5-th percentile	7.185488393e+10
Q1	1.163808261e+11
Median	1.20743827e+11
Q3	1.252188738e+11
95-th percentile	1.288860775e+11
Maximum	1.312048319e+11
Range	8.653452222e+10
Interquartile range	8838047627

Descriptive statistics

Standard deviation	1.340114151e+10
Coef of variation	0.1133306948
Kurtosis	9.655431823
Mean	1.182481192e+11
MAD	7351650408
Skewness	-3.107491641
Sum	9.716719924e+16
Variance	1.795905938e+20
Memory size	6.3 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[4.46703097e+10 4.47151193e+10 4.62981948e+10 4.63138759e+10 4.66250245e+10 ... 1.30968388e+11 1.30981288e+11 1.30985996e+11 1.31082690e+11 1.31204832e+11], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1.158186255e+11	430	0.1%
1.261964064e+11	400	< 0.1%
5.424918312e+10	392	< 0.1%
1.194551677e+11	327	< 0.1%
1.207425129e+11	320	< 0.1%
1.125396841e+11	301	< 0.1%
1.158679906e+11	300	< 0.1%
6.360703087e+10	297	< 0.1%
1.187367686e+11	294	< 0.1%
1.166253735e+11	294	< 0.1%
Other values (291201)	818368	99.6%

Minimum 5 values

Value	Count	Frequency (%)
4.467030971e+10	20	< 0.1%
4.475992891e+10	7	< 0.1%
4.492563245e+10	1	< 0.1%
4.497236934e+10	1	< 0.1%
4.532891885e+10	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.312048319e+11	1	< 0.1%
1.312045691e+11	1	< 0.1%
1.312044815e+11	1	< 0.1%
1.312020286e+11	1	< 0.1%
1.312018972e+11	1	< 0.1%

case_participant_id
Highly correlated

This variable is highly correlated with case_id and should be ignored for analysis

Correlation	0.9862112296

charge_count
Numeric

Distinct count	301
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	5.607300757
Minimum	1
Maximum	301
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	5
95-th percentile	19
Maximum	301
Range	300
Interquartile range	4

Descriptive statistics

Standard deviation	12.17660369
Coef of variation	2.171562436
Kurtosis	116.1180508
Mean	5.607300757
MAD	5.349972242
Skewness	8.708297781
Sum	4607648
Variance	148.2696774
Memory size	6.3 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 147.5 183.5 244.5 261.5 301. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	304534	37.1%
2	130317	15.9%
3	77082	9.4%
4	60487	7.4%
5	44012	5.4%
6	37213	4.5%
7	26410	3.2%
8	21673	2.6%
9	16220	2.0%
10	12947	1.6%
Other values (291)	90828	11.1%

Minimum 5 values

Value	Count	Frequency (%)
1	304534	37.1%
2	130317	15.9%
3	77082	9.4%
4	60487	7.4%
5	44012	5.4%

Maximum 5 values

Value	Count	Frequency (%)
301	1	< 0.1%
300	1	< 0.1%
299	1	< 0.1%
298	1	< 0.1%
297	1	< 0.1%

charge_disposition
Categorical

Distinct count	36
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Nolle Prosecution	502967
Plea Of Guilty	203390
FNG	37557
Other values (33)	77809

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Nolle Prosecution	502967	61.2%
Plea Of Guilty	203390	24.8%
FNG	37557	4.6%
FNPC	34152	4.2%
Finding Guilty	22345	2.7%
Verdict Guilty	4721	0.6%
Verdict-Not Guilty	3943	0.5%
Death Suggested-Cause Abated	3647	0.4%
BFW	2052	0.2%
Superseded by Indictment	1664	0.2%
Other values (26)	5285	0.6%

Max length	32
Mean length	15.03468931
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

charge_disposition_reason
Categorical

Distinct count	30
Unique (%)	< 0.1%
Missing (%)	73.3%
Missing (n)	602411

PG to Other Count/s	127892
Proceeding on Other Count/s	33162
Nolle - AONIC	13811
Other values (26)	44447
(Missing)	602411

Toggle details

Common values
Composition

Value	Count	Frequency (%)
PG to Other Count/s	127892	15.6%
Proceeding on Other Count/s	33162	4.0%
Nolle - AONIC	13811	1.7%
DGS Graduation	4692	0.6%
Motion to Quash Arrest & Suppress Evidence/Sustained	4450	0.5%
Re-Indictment	4221	0.5%
Misdemeanor Amount	4138	0.5%
Proceeding on Other Case/s	3727	0.5%
Complaining Witness Not in Court	3668	0.4%
No Lab	3368	0.4%
Other values (19)	16183	2.0%
(Missing)	602411	73.3%

Max length	52
Mean length	7.668299415
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

charge_id
Highly correlated

This variable is highly correlated with case_participant_id and should be ignored for analysis

Correlation	0.9583841653

charge_version_id
Highly correlated

This variable is highly correlated with charge_id and should be ignored for analysis

Correlation	0.9683668011

court_facility
Categorical

Distinct count	17
Unique (%)	< 0.1%
Missing (%)	1.0%
Missing (n)	8469

26TH Street	440181
Markham Courthouse	79200
Bridgeview Courthouse	77590
Other values (13)	216283

Toggle details

Common values
Composition

Value	Count	Frequency (%)
26TH Street	440181	53.6%
Markham Courthouse	79200	9.6%
Bridgeview Courthouse	77590	9.4%
Skokie Courthouse	75543	9.2%
Maywood Courthouse	47226	5.7%
Rolling Meadows Courthouse	37654	4.6%
Harrison & Kedzie (Area 4)	15174	1.8%
51st & Wentworth (Area 1)	10914	1.3%
Grand & Central (Area 5)	9650	1.2%
727 E. 111th Street (Area 2)	8611	1.0%
Other values (6)	11511	1.4%
(Missing)	8469	1.0%

Max length	30
Mean length	15.0265284
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

court_name
Categorical

Distinct count	9
Unique (%)	< 0.1%
Missing (%)	0.7%
Missing (n)	5550

District 1 - Chicago	495971
District 6 - Markham	79859
District 5 - Bridgeview	77708
Other values (5)	162635

Toggle details

Common values
Composition

Value	Count	Frequency (%)
District 1 - Chicago	495971	60.4%
District 6 - Markham	79859	9.7%
District 5 - Bridgeview	77708	9.5%
District 2 - Skokie	76650	9.3%
District 4 - Maywood	47754	5.8%
District 3 - Rolling Meadows	37828	4.6%
PROMIS	402	< 0.1%
Traffic	1	< 0.1%
(Missing)	5550	0.7%

Max length	28
Mean length	20.4370171
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

disposition_charged_act
Categorical

Distinct count	52
Unique (%)	< 0.1%
Missing (%)	2.8%
Missing (n)	23341

5	600690
570	160533
550	24394
Other values (48)	12765
(Missing)	23341

Toggle details

Common values
Composition

Value	Count	Frequency (%)
5	600690	73.1%
570	160533	19.5%
550	24394	3.0%
150	3972	0.5%
335	1959	0.2%
65	1876	0.2%
646	1486	0.2%
250	1371	0.2%
154	474	0.1%
70	369	< 0.1%
Other values (41)	1258	0.2%
(Missing)	23341	2.8%

Max length	5
Mean length	1.53471547
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

disposition_charged_aoic
Categorical

Distinct count	3298
Unique (%)	0.4%
Missing (%)	< 0.1%
Missing (n)	193

5101110	103600
0012476	22523
0014717	21035
Other values (3294)	674372

Toggle details

Common values
Composition

Value	Count	Frequency (%)
5101110	103600	12.6%
0012476	22523	2.7%
0014717	21035	2.6%
0012309	18769	2.3%
0735000	18494	2.3%
0016108	17439	2.1%
0012474	17283	2.1%
5097200	16471	2.0%
0014716	15720	1.9%
0014056	15068	1.8%
Other values (3287)	555128	67.6%

Max length	10
Mean length	7.156510162
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

disposition_charged_chapter
Categorical

Distinct count	858
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0

720	672604
625	111167
730	9316
Other values (855)	28636

Toggle details

Common values
Composition

Value	Count	Frequency (%)
720	672604	81.9%
625	111167	13.5%
730	9316	1.1%
720-5\8-4(720-5\9-1)	2514	0.3%
15	1959	0.2%
430	1917	0.2%
720-570\402(C)	940	0.1%
720-5\10-3.1	885	0.1%
720-5\18-2(A)(2)	794	0.1%
720-5\12-4(A)	780	0.1%
Other values (848)	18847	2.3%

Max length	24
Mean length	3.357978297
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

disposition_charged_class
Categorical

Distinct count	14
Unique (%)	< 0.1%
Missing (%)	< 0.1%
Missing (n)	170

4	341449
2	174458
3	122749
Other values (10)	182897

Toggle details

Common values
Composition

Value	Count	Frequency (%)
4	341449	41.6%
2	174458	21.2%
3	122749	14.9%
X	78539	9.6%
1	64240	7.8%
M	22303	2.7%
A	16428	2.0%
B	739	0.1%
C	455	0.1%
Z	115	< 0.1%
Other values (3)	78	< 0.1%
(Missing)	170	< 0.1%

Max length	3
Mean length	1.000413765
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

disposition_charged_offense_title
Categorical

Distinct count	2302
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

POSSESSION OF A CONTROLLED SUBSTANCE	105281
AGGRAVATED UNLAWFUL USE OF WEAPON	98855
AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL	54853
Other values (2299)	562734

Toggle details

Common values
Composition

Value	Count	Frequency (%)
POSSESSION OF A CONTROLLED SUBSTANCE	105281	12.8%
AGGRAVATED UNLAWFUL USE OF WEAPON	98855	12.0%
AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL	54853	6.7%
AGGRAVATED BATTERY	45636	5.6%
FELONY DRIVING WHILE DRIVER?S LICENSE, PERMIT, OR PRIVILEGE TO OPERATE A MOTOR VEHICLE IS SUSPENDED OR REVOKED	37911	4.6%
UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON	35566	4.3%
[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE]	25699	3.1%
RETAIL THEFT	21282	2.6%
THEFT	18581	2.3%
[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/ DELIVERY OF A CONTROLLED SUBSTANCE]	17002	2.1%
Other values (2292)	361057	43.9%

Max length	120
Mean length	38.8769634
Min length	5
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

disposition_charged_section
Categorical

Distinct count	1635
Unique (%)	0.2%
Missing (%)	2.8%
Missing (n)	23341

402(c)	102823
24-1.6(a)(1)	72148
11-501(a)	55022
Other values (1631)	568389

Toggle details

Common values
Composition

Value	Count	Frequency (%)
402(c)	102823	12.5%
24-1.6(a)(1)	72148	8.8%
11-501(a)	55022	6.7%
6-303(a)	40748	5.0%
24-1.1(a)	35566	4.3%
24-1.6(a)(2)	35365	4.3%
16-25(a)(1)	17456	2.1%
12-3.05(d)(4)	17394	2.1%
401(d)(i)	16402	2.0%
8-4(a)(720-5/9-1(a)(1))	12253	1.5%
Other values (1624)	393205	47.9%
(Missing)	23341	2.8%

Max length	30
Mean length	9.444253112
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

disposition_date
Categorical

Distinct count	2802
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

10/30/2013 12:00:00 AM	801
5/11/2012 12:00:00 AM	760
7/10/2014 12:00:00 AM	733
Other values (2799)	819429

Toggle details

Common values
Composition

Value	Count	Frequency (%)
10/30/2013 12:00:00 AM	801	0.1%
5/11/2012 12:00:00 AM	760	0.1%
7/10/2014 12:00:00 AM	733	0.1%
9/17/2013 12:00:00 AM	726	0.1%
12/5/2013 12:00:00 AM	705	0.1%
10/6/2016 12:00:00 AM	692	0.1%
4/13/2016 12:00:00 AM	687	0.1%
4/18/2013 12:00:00 AM	685	0.1%
8/29/2012 12:00:00 AM	680	0.1%
10/24/2013 12:00:00 AM	679	0.1%
Other values (2792)	814575	99.1%

Max length	22
Mean length	20.95091412
Min length	20
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

gender
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	2945

Male	731532
Female	87228
Male name, no gender given	9
Other values (2)	9
(Missing)	2945

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Male	731532	89.0%
Female	87228	10.6%
Male name, no gender given	9	< 0.1%
Unknown	7	< 0.1%
Unknown Gender	2	< 0.1%
(Missing)	2945	0.4%

Max length	26
Mean length	4.209012039
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

incident_begin_date
Categorical

Distinct count	6465
Unique (%)	0.8%
Missing (%)	0.9%
Missing (n)	7614

1/1/2012 12:00:00 AM	782
1/1/2013 12:00:00 AM	705
10/18/2011 12:00:00 AM	655
Other values (6461)	811967
(Missing)	7614

Toggle details

Common values
Composition

Value	Count	Frequency (%)
1/1/2012 12:00:00 AM	782	0.1%
1/1/2013 12:00:00 AM	705	0.1%
10/18/2011 12:00:00 AM	655	0.1%
1/19/2017 12:00:00 AM	610	0.1%
9/10/2011 12:00:00 AM	597	0.1%
1/1/2011 12:00:00 AM	593	0.1%
1/1/2010 12:00:00 AM	581	0.1%
8/4/2011 12:00:00 AM	558	0.1%
9/1/2010 12:00:00 AM	556	0.1%
12/27/2011 12:00:00 AM	552	0.1%
Other values (6454)	807920	98.3%
(Missing)	7614	0.9%

Max length	22
Mean length	20.76304545
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

incident_city
Categorical

Distinct count	268
Unique (%)	< 0.1%
Missing (%)	9.0%
Missing (n)	73668

Chicago	535463
Cicero	10716
Harvey	7704
Other values (264)	194172
(Missing)	73668

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Chicago	535463	65.2%
Cicero	10716	1.3%
Harvey	7704	0.9%
Chicago Heights	6314	0.8%
Calumet City	5638	0.7%
Berwyn	5173	0.6%
Orland Park	5005	0.6%
Oak Lawn	4751	0.6%
Evanston	4511	0.5%
Dolton	4342	0.5%
Other values (257)	158438	19.3%
(Missing)	73668	9.0%

Max length	21
Mean length	7.347203376
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

incident_end_date
Categorical

Distinct count	4287
Unique (%)	0.5%
Missing (%)	88.7%
Missing (n)	729228

2/28/2013 12:00:00 AM	441
1/19/2017 12:00:00 AM	408
7/7/2004 12:00:00 AM	392
Other values (4283)	91254
(Missing)	729228

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2/28/2013 12:00:00 AM	441	0.1%
1/19/2017 12:00:00 AM	408	< 0.1%
7/7/2004 12:00:00 AM	392	< 0.1%
8/22/2011 12:00:00 AM	389	< 0.1%
9/11/2011 12:00:00 AM	321	< 0.1%
1/31/2007 12:00:00 AM	294	< 0.1%
3/12/2014 12:00:00 AM	250	< 0.1%
10/31/2014 12:00:00 AM	217	< 0.1%
7/23/2014 12:00:00 AM	201	< 0.1%
11/2/2008 12:00:00 AM	198	< 0.1%
Other values (4276)	89384	10.9%
(Missing)	729228	88.7%

Max length	22
Mean length	5.021989162
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

judge
Categorical

Distinct count	403
Unique (%)	< 0.1%
Missing (%)	8.5%
Missing (n)	69566

Brian K Flaherty	22254
James B Linn	19711
Michele M Pitman	19173
Other values (399)	691019
(Missing)	69566

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Brian K Flaherty	22254	2.7%
James B Linn	19711	2.4%
Michele M Pitman	19173	2.3%
Nicholas R Ford	18793	2.3%
Colleen Ann Hyland	16314	2.0%
James Michael Obbish	15250	1.9%
Joseph Michael Claps	14873	1.8%
Charles P Burns	14554	1.8%
Vincent M Gaughan	14412	1.8%
Kenneth J Wadas	14371	1.7%
Other values (392)	582452	70.9%
(Missing)	69566	8.5%

Max length	25
Mean length	15.43718382
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

law_enforcement_agency
Categorical

Distinct count	525
Unique (%)	0.1%
Missing (%)	0.1%
Missing (n)	1062

CHICAGO PD	527681
COOK COUNTY SHERIFF (IL0160000)	19804
CICERO PD	10908
Other values (521)	262268

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CHICAGO PD	527681	64.2%
COOK COUNTY SHERIFF (IL0160000)	19804	2.4%
CICERO PD	10908	1.3%
HARVEY PD	6713	0.8%
CHICAGO HEIGHTS PD	6267	0.8%
ORLAND PARK PD	5626	0.7%
CALUMET CITY PD	5353	0.7%
ISP DISTRICT CHICAGO	5333	0.6%
BERWYN PD	5100	0.6%
EVANSTON PD	4810	0.6%
Other values (514)	223066	27.1%

Max length	60
Mean length	12.31936188
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

offense_category
Categorical

Distinct count	88
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Narcotics	178419
UUW - Unlawful Use of Weapon	143369
Aggravated DUI	51759
Other values (85)	448176

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Narcotics	178419	21.7%
UUW - Unlawful Use of Weapon	143369	17.4%
Aggravated DUI	51759	6.3%
PROMIS Conversion	47380	5.8%
Sex Crimes	35874	4.4%
Driving With Suspended Or Revoked License	30798	3.7%
Armed Robbery	25212	3.1%
Aggravated Battery Police Officer	23070	2.8%
Retail Theft	23025	2.8%
Homicide	22090	2.7%
Other values (78)	240727	29.3%

Max length	45
Mean length	17.29490351
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

primary_charge
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	517189
True	304534

Toggle details

Value	Count	Frequency (%)
False	517189	62.9%
True	304534	37.1%

race
Categorical

Distinct count	12
Unique (%)	< 0.1%
Missing (%)	0.5%
Missing (n)	4183

Black	547288
White [Hispanic or Latino]	132201
White	107873
Other values (8)	30178

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Black	547288	66.6%
White [Hispanic or Latino]	132201	16.1%
White	107873	13.1%
HISPANIC	18937	2.3%
Asian	5168	0.6%
White/Black [Hispanic or Latino]	4110	0.5%
Unknown	1141	0.1%
American Indian	427	0.1%
ASIAN	279	< 0.1%
Biracial	115	< 0.1%
(Missing)	4183	0.5%

Max length	32
Mean length	8.580931774
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

received_date
Categorical

Distinct count	6033
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

10/18/2011 12:00:00 AM	877
8/23/2011 12:00:00 AM	723
8/5/2011 12:00:00 AM	705
Other values (6030)	819418

Toggle details

Common values
Composition

Value	Count	Frequency (%)
10/18/2011 12:00:00 AM	877	0.1%
8/23/2011 12:00:00 AM	723	0.1%
8/5/2011 12:00:00 AM	705	0.1%
1/25/2012 12:00:00 AM	687	0.1%
11/16/2011 12:00:00 AM	641	0.1%
6/28/2013 12:00:00 AM	638	0.1%
1/21/2017 12:00:00 AM	630	0.1%
8/28/2012 12:00:00 AM	613	0.1%
10/21/2013 12:00:00 AM	587	0.1%
7/30/2012 12:00:00 AM	570	0.1%
Other values (6023)	815052	99.2%

Max length	22
Mean length	20.94496199
Min length	20
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

unit
Categorical

Distinct count	101
Unique (%)	< 0.1%
Missing (%)	69.6%
Missing (n)	571681

District 11 - Harrison	48071
District 10 - Ogden	20216
District 15 - Austin	18183
Other values (97)	163572
(Missing)	571681

Toggle details

Common values
Composition

Value	Count	Frequency (%)
District 11 - Harrison	48071	5.9%
District 10 - Ogden	20216	2.5%
District 15 - Austin	18183	2.2%
District 7 - Englewood	17160	2.1%
District 6 - Gresham	14477	1.8%
District 25 - Grand Central	13682	1.7%
District 8 - Chicago Lawn	11383	1.4%
District 9 - Deering	11377	1.4%
District 5 - Calumet	11182	1.4%
District 4 - South Chicago	9813	1.2%
Other values (90)	74498	9.1%
(Missing)	571681	69.6%

Max length	57
Mean length	9.043476938
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

updated_offense_category
Categorical

Distinct count	81
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Narcotics	188762
UUW - Unlawful Use of Weapon	148956
Aggravated DUI	65161
Other values (78)	418844

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Narcotics	188762	23.0%
UUW - Unlawful Use of Weapon	148956	18.1%
Aggravated DUI	65161	7.9%
Sex Crimes	39498	4.8%
Homicide	31552	3.8%
Driving With Suspended Or Revoked License	31409	3.8%
Aggravated Battery With A Firearm	29055	3.5%
Armed Robbery	26005	3.2%
Aggravated Battery Police Officer	24684	3.0%
Retail Theft	22396	2.7%
Other values (71)	214245	26.1%

Max length	45
Mean length	17.5830651
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

First rows

	age_at_incident	arraignment_date	arrest_date	case_id	case_participant_id	charge_count	charge_disposition	charge_disposition_reason	charge_id	charge_version_id	court_facility	court_name	disposition_charged_act	disposition_charged_aoic	disposition_charged_chapter	disposition_charged_class	disposition_charged_offense_title	disposition_charged_section	disposition_date	gender	incident_begin_date	incident_city	incident_end_date	judge	law_enforcement_agency	offense_category	primary_charge	race	received_date	unit	updated_offense_category
0	43.0	2/1/2012 12:00:00 AM	12/29/2011 12:10:00 PM	116240177428	908314430833	1	Nolle Prosecution	Proceeding on Other Count/s	2077894472647	472118710537	26TH Street	District 1 - Chicago	5	0012300	720	2	AGGRAVATED DOMESTIC BATTERY	12-3.3(a)	9/25/2012 12:00:00 AM	Male	12/8/2011 12:00:00 AM	Chicago	NaN	Vincent M Gaughan	CHICAGO PD	Domestic Battery	True	Black	1/3/2012 12:00:00 AM	NaN	Domestic Battery
1	42.0	1/31/2012 12:00:00 AM	1/3/2012 12:05:00 PM	116240221230	908314782607	1	Plea Of Guilty	NaN	2074969691100	471445411764	26TH Street	District 1 - Chicago	5	0015600	720	4	RETAIL THEFT	16A-3(a)	6/22/2012 12:00:00 AM	Male	1/3/2012 12:00:00 AM	Chicago	NaN	Michael Brown	CHICAGO PD	Retail Theft	True	Black	1/3/2012 12:00:00 AM	NaN	Retail Theft
2	50.0	2/9/2012 12:00:00 AM	12/29/2011 11:55:00 AM	116240265032	908315368896	1	Plea Of Guilty	NaN	2074970874144	471445680278	26TH Street	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	7/18/2012 12:00:00 AM	Male	12/29/2011 12:00:00 AM	Chicago	NaN	William H Hooks	CHICAGO PD	Narcotics	True	Black	1/3/2012 12:00:00 AM	District 12 - Monroe	Narcotics
3	28.0	2/8/2012 12:00:00 AM	12/29/2011 2:11:00 PM	116240352636	908315720670	1	Plea Of Guilty	NaN	2074973831755	471446351563	26TH Street	District 1 - Chicago	550	5020300	720	3	[POSSESSION OF CANNABIS WITH INTENT TO DELIVER/DELIVERY OF CANNABIS]	5(d)	9/27/2012 12:00:00 AM	Male	12/29/2011 12:00:00 AM	Chicago	NaN	William H Hooks	CHICAGO PD	Narcotics	True	Black	1/3/2012 12:00:00 AM	District 4 - South Chicago	Narcotics
4	25.0	2/8/2012 12:00:00 AM	12/29/2011 11:00:00 AM	116240396439	908316658734	1	Plea Of Guilty	NaN	2074979451216	487873767563	26TH Street	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	1/3/2013 12:00:00 AM	Male	12/29/2011 12:00:00 AM	Chicago	NaN	Raymond Myles	CHICAGO PD	Narcotics	True	Black	1/3/2012 12:00:00 AM	District 11 - Harrison	Narcotics
5	18.0	2/8/2012 12:00:00 AM	12/29/2011 11:00:00 AM	116240396439	908317010508	1	Plea Of Guilty	NaN	2074979451216	471447627005	26TH Street	District 1 - Chicago	570	0013009	720	1	[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE]	401(c)(1)	2/22/2012 12:00:00 AM	Female	12/29/2011 12:00:00 AM	Chicago	NaN	Raymond Myles	CHICAGO PD	Narcotics	True	Black	1/3/2012 12:00:00 AM	District 11 - Harrison	Narcotics
6	23.0	2/14/2012 12:00:00 AM	12/27/2011 10:00:00 AM	116240440241	908317479540	2	Nolle Prosecution	NaN	2076733610318	471849525285	26TH Street	District 1 - Chicago	5	0012300	720	2	AGGRAVATED DOMESTIC BATTERY	12-3.3(a)	6/20/2013 12:00:00 AM	Male	12/16/2011 12:00:00 AM	Chicago	NaN	James Michael Obbish	CHICAGO PD	Aggravated Battery	False	Black	1/3/2012 12:00:00 AM	NaN	Domestic Battery
7	23.0	2/14/2012 12:00:00 AM	12/27/2011 10:00:00 AM	116240440241	908317479540	3	Nolle Prosecution	NaN	2077257107470	471970960727	26TH Street	District 1 - Chicago	5	0014834	720	2	AGGRAVATED DOMESTIC BATTERY	12-3.3(a-5)	6/20/2013 12:00:00 AM	Male	12/16/2011 12:00:00 AM	Chicago	NaN	James Michael Obbish	CHICAGO PD	Aggravated Battery	False	Black	1/3/2012 12:00:00 AM	NaN	Domestic Battery
8	23.0	2/14/2012 12:00:00 AM	12/27/2011 10:00:00 AM	116240440241	908317479540	4	Nolle Prosecution	NaN	2079629703038	472517856549	26TH Street	District 1 - Chicago	5	0014834	720	2	AGGRAVATED DOMESTIC BATTERY	12-3.3(a-5)	6/20/2013 12:00:00 AM	Male	12/16/2011 12:00:00 AM	Chicago	NaN	James Michael Obbish	CHICAGO PD	Aggravated Battery	False	Black	1/3/2012 12:00:00 AM	NaN	Domestic Battery
9	23.0	2/14/2012 12:00:00 AM	12/27/2011 10:00:00 AM	116240440241	908317479540	5	Nolle Prosecution	NaN	2076733906079	471849592413	26TH Street	District 1 - Chicago	5	0016094	720	3	AGGRAVATED BATTERY	12-3.05(a)(1)	6/20/2013 12:00:00 AM	Male	12/16/2011 12:00:00 AM	Chicago	NaN	James Michael Obbish	CHICAGO PD	Aggravated Battery	False	Black	1/3/2012 12:00:00 AM	NaN	Domestic Battery

Last rows

	age_at_incident	arraignment_date	arrest_date	case_id	case_participant_id	charge_count	charge_disposition	charge_disposition_reason	charge_id	charge_version_id	court_facility	court_name	disposition_charged_act	disposition_charged_aoic	disposition_charged_chapter	disposition_charged_class	disposition_charged_offense_title	disposition_charged_section	disposition_date	gender	incident_begin_date	incident_city	incident_end_date	judge	law_enforcement_agency	offense_category	primary_charge	race	received_date	unit	updated_offense_category
821713	24.0	NaN	10/17/2019 5:25:00 PM	131198874833	1101045483863	1	Nolle Prosecution	NaN	2584493314237	589445217220	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	10/18/2019 12:00:00 AM	Female	10/17/2019 12:00:00 AM	Chicago	10/17/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	White	11/21/2019 12:00:00 AM	NaN	Narcotics
821714	28.0	NaN	10/6/2019 1:03:00 PM	131199050042	1101046890958	1	Nolle Prosecution	NaN	2584493905759	589445418605	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	10/7/2019 12:00:00 AM	Male	10/6/2019 12:00:00 AM	Chicago	10/6/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/21/2019 12:00:00 AM	NaN	Narcotics
821715	26.0	NaN	10/6/2019 1:03:00 PM	131199444261	1101052167567	1	Nolle Prosecution	NaN	2584499525220	589446895432	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	10/7/2019 12:00:00 AM	Female	10/6/2019 12:00:00 AM	Chicago	10/6/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/21/2019 12:00:00 AM	NaN	Narcotics
821716	65.0	NaN	11/6/2019 11:01:00 AM	131199575668	1101053105631	1	Nolle Prosecution	NaN	2584500116742	589447163946	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	11/7/2019 12:00:00 AM	Male	11/6/2019 12:00:00 AM	Chicago	11/6/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/21/2019 12:00:00 AM	NaN	Narcotics
821717	56.0	NaN	11/5/2019 11:17:00 AM	131199838481	1101056388854	1	Nolle Prosecution	Misdemeanor Amount	2584509581097	589449312058	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	11/6/2019 12:00:00 AM	Female	11/5/2019 12:00:00 AM	Chicago	11/5/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/21/2019 12:00:00 AM	NaN	Narcotics
821718	62.0	NaN	11/6/2019 2:36:00 PM	131201897182	1101083006411	1	Nolle Prosecution	NaN	2584590915401	589468040907	26TH Street	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	11/7/2019 12:00:00 AM	Male	11/6/2019 12:00:00 AM	Chicago	11/6/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/21/2019 12:00:00 AM	NaN	Narcotics
821719	31.0	NaN	11/6/2019 2:13:00 PM	131202028588	1101084648023	1	Nolle Prosecution	NaN	2584594760295	589469114963	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	11/7/2019 12:00:00 AM	Male	11/6/2019 12:00:00 AM	Chicago	11/6/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/21/2019 12:00:00 AM	NaN	Narcotics
821720	18.0	NaN	11/6/2019 2:08:00 PM	131204481509	1101121467024	1	Nolle Prosecution	NaN	2584653616754	589482876304	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	11/7/2019 12:00:00 AM	Male	11/6/2019 12:00:00 AM	Chicago	11/6/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/22/2019 12:00:00 AM	NaN	Narcotics
821721	27.0	NaN	11/6/2019 6:27:00 PM	131204569113	1101123108635	1	Nolle Prosecution	NaN	2584658940454	589484151745	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	11/7/2019 12:00:00 AM	Male	11/6/2019 12:00:00 AM	Chicago	11/6/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/22/2019 12:00:00 AM	NaN	Narcotics
821722	39.0	NaN	10/17/2019 12:47:00 PM	131204831926	1101125805568	1	Nolle Prosecution	NaN	2584662193826	589484890159	NaN	District 1 - Chicago	570	5101110	720	4	POSSESSION OF A CONTROLLED SUBSTANCE	402(c)	11/18/2019 12:00:00 AM	Female	10/17/2019 12:00:00 AM	Chicago	10/17/2019 12:00:00 AM	NaN	CHICAGO PD	Narcotics	True	Black	11/22/2019 12:00:00 AM	NaN	Narcotics

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows